hi friends i am a junior developer i have assigned a project by my team leader. in this project use ms access database and i need to set two column primary keys in a table . please help me any one .
thanks.
Home / DeveloperSection / Forums / How do you set two primary keys in access?
hi friends i am a junior developer i have assigned a project by my team leader. in this project use ms access database and i need to set two column primary keys in a table . please help me any one .
thanks.
Anonymous User
27-Jul-2020Add a two field as a primary key
1. Open MS Access and select the Blank Desktop database.
See below image ->
2. After clicking the Blank Desktop database a popup will be open.
See below image ->
3. In the Navigation Pane, right-click the table and click Design View.
see below image->
4. Now select two-column to which you want to add the primary key and click the primary key button.
See below image->
I hope it will help to you.